sql="select P.*,T.name as Typename from tb_function P inner join tb_Type ......
来源:百度知道 编辑:UC知道 时间:2024/05/29 02:08:52
sql="select P.*,T.name as Typename from tb_function P inner join tb_Type T on P.Type= T.ID where P.Type="&rs_Type("ID")&" order by P.hit desc"
请帮忙详细解释这句话的意思。谢谢!!!
请帮忙详细解释这句话的意思。谢谢!!!
就是一个sql语句。它的意思是:
tb_function表和tb_Type表内连接条件是:P.Type列值等于rs_Type("ID"),按p.hit列倒序。
SELECT P.*, T.Name AS TypeName
FROM tb_Function AS P
INNER JOIN tb_Type AS T
ON (P.Type = T.ID)
WHERE (P.Type = " & rs_Type("ID").Value & ")
ORDER BY P.Hit DESC
其实就是这么一个SQL语句,P、T两表连接,返回类别是rs_Type("ID").Value的P表的全部字段和T.Name,并按照P.Hit字段排序。
sql="select * from user"
sql="select * from问题
sql="select * from sg where
sql="select * from……"
sql = "Select top 5 * from news"
sql="select top 5 news.* from 问题
SQL:select top 1 [id] [id] like '"+p+"1%' order by [id] desc中的1%是什么意思
sql="select * from 表名 where 字段名=' "& document.Form.Select.value" ' "
sql = "Select * From [userinfo] Where userid = '"&userid&"'" ;
sql="select top 10 * from jjh_news where news_fenlei="&Request("news_fenlei")